1 Load data

df <- read.table('../../../output/first_try/report/summary_table.txt', header = T)
df$rownum <- 1 : nrow(df)

df.sub <- df[df$motif_qval < 0.05 & df$r2 > 0.5, ]
df.sub$strand <- as.character(df.sub$strand)
df.sub$strand[df.sub$strand == '-'] <- 'negative'
df.sub$strand[df.sub$strand == '+'] <- 'positive'
row.names(df.sub) <- NULL
motif_logo_prefix <- '../../../output/first_try/report/motif_logo/'
mash_plot_prefix <- '../../../output/first_try/report/mash_plot//mash__idx'
for(i in 1 : nrow(df.sub)) {
    motif_logo <- paste0(motif_logo_prefix, df.sub$dbname[i], '__', df.sub$motif_id[i], '.png')
    mash_plot <- paste0(mash_plot_prefix, df.sub$idx[i], '.png')
    cat('#', as.character(df.sub$gene_name[i]), as.character(df$motif_id[i]), '\n', '\n')
    df.show <- df.sub[, - which(colnames(df.sub) %in% c('idx', 'motif_from', 'motif_matched_sequence', 'motif_qval', 'dbname', 'rownum'))]
    pander(df.show[i, ])
    img1 <- rasterGrob(as.raster(readPNG(motif_logo)), interpolate = FALSE)
    img2 <- rasterGrob(as.raster(readPNG(mash_plot)), interpolate = FALSE)
    grid.arrange(img1, img2, ncol = 2)
    # cat(motif_logo, mash_plot, '\n')
    # df.sub[i, ] %>% kable(format = "html", col.names = colnames(df.sub)) %>%
    #   kable_styling() %>%
    #   kableExtra::scroll_box(width = "100%", height = "200px")
    cat('\n', '\n')
}

2 TMA7 COT2_HUMAN.H11MO.1.A

gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 0.9998 SP1_HUMAN.H11MO.1.A NA 2 14 positive Heart_Atrial_Appendage

3 TMA7 COT2_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
2 TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 0.9998 SP1_HUMAN.H11MO.0.A NA 2 22 positive Heart_Atrial_Appendage

4 PDIA2 MA0512.2

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
3 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.1.A NA 8 14 negative Heart_Atrial_Appendage

5 PDIA2 MA0677.1

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
4 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 8 22 negative Heart_Atrial_Appendage

6 PDIA2 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
5 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 15 22 negative Heart_Atrial_Appendage

7 PDIA2 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
6 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 2 22 negative Heart_Atrial_Appendage

8 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
7 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 17 22 negative Heart_Atrial_Appendage

9 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
8 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 13 22 negative Heart_Atrial_Appendage

10 PRKCA MEF2A_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
9 PRKCA ENSG00000154229 17_64315205_A_C_b37 17_64298682_G_A_b37 0.8253 SP1_HUMAN.H11MO.0.A NA 21 22 positive Heart_Atrial_Appendage

11 PRKCA SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
10 PRKCA ENSG00000154229 17_64315205_A_C_b37 17_64298682_G_A_b37 0.8253 SP1_HUMAN.H11MO.0.A NA 16 22 negative Heart_Atrial_Appendage

12 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
11 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.5002 SP1_HUMAN.H11MO.0.A NA 22 22 negative Heart_Atrial_Appendage

13 RAB40B SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
12 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.5002 SP1_HUMAN.H11MO.0.A NA 12 22 negative Heart_Atrial_Appendage

14 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
13 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.5002 SP1_HUMAN.H11MO.0.A NA 17 22 negative Heart_Atrial_Appendage

15 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
14 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.5002 SP1_HUMAN.H11MO.1.A NA 12 14 negative Heart_Atrial_Appendage

16 SIPA1L3 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
15 SIPA1L3 ENSG00000105738 19_38670754_C_T_b37 19_38664097_C_T_b37 0.9999 SP1_HUMAN.H11MO.0.A NA 14 22 negative Heart_Atrial_Appendage

17 SIPA1L3 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
16 SIPA1L3 ENSG00000105738 19_38670754_C_T_b37 19_38664097_C_T_b37 0.9999 SP1_HUMAN.H11MO.0.A NA 18 22 positive Heart_Atrial_Appendage

18 CCDC157 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
17 CCDC157 ENSG00000187860 22_30765502_G_A_b37 22_30752942_C_A_b37 0.9667 SP1_HUMAN.H11MO.0.A NA 8 22 negative Heart_Atrial_Appendage

19 CCDC157 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
18 CCDC157 ENSG00000187860 22_30765502_G_A_b37 22_30752942_C_A_b37 0.9667 SP1_HUMAN.H11MO.0.A NA 2 22 negative Heart_Atrial_Appendage

20 TMA7 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
19 TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 0.9998 MA0079.3 SP1 11 11 negative Heart_Atrial_Appendage

21 PDIA2 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
20 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 MA0079.3 SP1 5 11 positive Heart_Atrial_Appendage

22 WDR59 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
21 WDR59 ENSG00000103091 16_74937232_T_A_b37 16_74938857_G_A_b37 0.5144 MA0512.2 Rxra 13 14 negative Heart_Left_Ventricle

23 TMA7 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
22 TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 0.9998 SP1_HUMAN.H11MO.1.A NA 2 14 positive Heart_Left_Ventricle

24 TMA7 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
23 TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 0.9998 SP1_HUMAN.H11MO.0.A NA 2 22 positive Heart_Left_Ventricle

25 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
24 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.1.A NA 8 14 negative Heart_Left_Ventricle

26 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
25 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 8 22 negative Heart_Left_Ventricle

27 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
26 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 15 22 negative Heart_Left_Ventricle

28 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
27 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 2 22 negative Heart_Left_Ventricle

29 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
28 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 17 22 negative Heart_Left_Ventricle

30 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
29 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 13 22 negative Heart_Left_Ventricle

31 PRKCA SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
30 PRKCA ENSG00000154229 17_64315205_A_C_b37 17_64298682_G_A_b37 0.7719 SP1_HUMAN.H11MO.0.A NA 21 22 positive Heart_Left_Ventricle

32 PRKCA SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
31 PRKCA ENSG00000154229 17_64315205_A_C_b37 17_64298682_G_A_b37 0.7719 SP1_HUMAN.H11MO.0.A NA 16 22 negative Heart_Left_Ventricle

33 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
32 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.5906 SP1_HUMAN.H11MO.0.A NA 22 22 negative Heart_Left_Ventricle

34 RAB40B SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
33 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.5906 SP1_HUMAN.H11MO.0.A NA 12 22 negative Heart_Left_Ventricle

35 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
34 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.5906 SP1_HUMAN.H11MO.0.A NA 17 22 negative Heart_Left_Ventricle

36 RAB40B SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
35 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.5906 SP1_HUMAN.H11MO.1.A NA 12 14 negative Heart_Left_Ventricle

37 SIPA1L3 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
36 SIPA1L3 ENSG00000105738 19_38670754_C_T_b37 19_38664097_C_T_b37 0.9999 SP1_HUMAN.H11MO.0.A NA 14 22 negative Heart_Left_Ventricle

38 SIPA1L3 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
37 SIPA1L3 ENSG00000105738 19_38670754_C_T_b37 19_38664097_C_T_b37 0.9999 SP1_HUMAN.H11MO.0.A NA 18 22 positive Heart_Left_Ventricle

39 CCDC157 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
38 CCDC157 ENSG00000187860 22_30765502_G_A_b37 22_30752942_C_A_b37 0.9617 SP1_HUMAN.H11MO.0.A NA 8 22 negative Heart_Left_Ventricle

40 CCDC157 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
39 CCDC157 ENSG00000187860 22_30765502_G_A_b37 22_30752942_C_A_b37 0.9617 SP1_HUMAN.H11MO.0.A NA 2 22 negative Heart_Left_Ventricle

41 TMA7 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
40 TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 0.9998 MA0079.3 SP1 11 11 negative Heart_Left_Ventricle

42 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
41 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 MA0079.3 SP1 5 11 positive Heart_Left_Ventricle

43 TMA7 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
42 TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 0.9999 SP1_HUMAN.H11MO.1.A NA 2 14 positive Muscle_Skeletal

44 TMA7 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
43 TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 0.9999 SP1_HUMAN.H11MO.0.A NA 2 22 positive Muscle_Skeletal

45 PDIA2 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
44 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.1.A NA 8 14 negative Muscle_Skeletal

46 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
45 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 8 22 negative Muscle_Skeletal

47 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
46 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 15 22 negative Muscle_Skeletal

48 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
47 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 2 22 negative Muscle_Skeletal

49 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
48 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 17 22 negative Muscle_Skeletal

50 PDIA2 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
49 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 SP1_HUMAN.H11MO.0.A NA 13 22 negative Muscle_Skeletal

51 PRKCA SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
50 PRKCA ENSG00000154229 17_64315205_A_C_b37 17_64298682_G_A_b37 0.7876 SP1_HUMAN.H11MO.0.A NA 21 22 positive Muscle_Skeletal

52 PRKCA SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
51 PRKCA ENSG00000154229 17_64315205_A_C_b37 17_64298682_G_A_b37 0.7876 SP1_HUMAN.H11MO.0.A NA 16 22 negative Muscle_Skeletal

53 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
52 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.5207 SP1_HUMAN.H11MO.0.A NA 22 22 negative Muscle_Skeletal

54 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
53 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.5207 SP1_HUMAN.H11MO.0.A NA 12 22 negative Muscle_Skeletal

55 RAB40B SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
54 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.5207 SP1_HUMAN.H11MO.0.A NA 17 22 negative Muscle_Skeletal

56 RAB40B SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
55 RAB40B ENSG00000141542 17_80645286_C_G_b37 17_80656616_T_G_b37 0.5207 SP1_HUMAN.H11MO.1.A NA 12 14 negative Muscle_Skeletal

57 SIPA1L3 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
56 SIPA1L3 ENSG00000105738 19_38670754_C_T_b37 19_38664097_C_T_b37 0.9995 SP1_HUMAN.H11MO.0.A NA 14 22 negative Muscle_Skeletal

58 SIPA1L3 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
57 SIPA1L3 ENSG00000105738 19_38670754_C_T_b37 19_38664097_C_T_b37 0.9995 SP1_HUMAN.H11MO.0.A NA 18 22 positive Muscle_Skeletal

59 CCDC157 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
58 CCDC157 ENSG00000187860 22_30765502_G_A_b37 22_30752942_C_A_b37 0.9702 SP1_HUMAN.H11MO.0.A NA 8 22 negative Muscle_Skeletal

60 CCDC157 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
59 CCDC157 ENSG00000187860 22_30765502_G_A_b37 22_30752942_C_A_b37 0.9702 SP1_HUMAN.H11MO.0.A NA 2 22 negative Muscle_Skeletal

61 TMA7 SP1_HUMAN.H11MO.0.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
60 TMA7 ENSG00000232112 3_48479207_C_T_b37 3_48481647_G_A_b37 0.9999 MA0079.3 SP1 11 11 negative Muscle_Skeletal

62 PDIA2 SP1_HUMAN.H11MO.1.A

  gene_name ensembl_gene_id leading_eqtl motif_snp r2 motif_id motif_name motif_snp.pos motif.length strand tissue
61 PDIA2 ENSG00000185615 16_333146_C_T_b37 16_333146_C_T_b37 1 MA0079.3 SP1 5 11 positive Muscle_Skeletal